-- ----------------------------
--  Records ofsys_dept`
-- ----------------------------
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 1, '集团总公司', 'YD', 0, SYSDATE, SYSDATE, '0', 0, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 2, '东北区域', 'DB', 0, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 3, '河南区域', 'HN', 1, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 4, '江西区域', 'JX', 2, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 5, '内蒙公司', 'NM', 3, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 6, '西北区域', 'XB', 4, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
INSERT INTO sys_dept ( dept_id, name, dept_code, sort, create_time, update_time, del_flag, parent_id, remark, tenant_id )
VALUES
	( 7, '西南区域', 'XN', 5, SYSDATE, SYSDATE, '0', 1, NULL, 1 );
COMMIT;
-- ----------------------------
--  Records ofsys_dept_relation`
-- ----------------------------
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 1 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 2 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 3 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 4 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 5 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 6 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 1, 7 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 2, 2 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 3, 3 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 4, 4 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 5, 5 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 6, 6 );
INSERT INTO sys_dept_relation ( ancestor, descendant )
VALUES
	( 7, 7 );
COMMIT;
-- ----------------------------
--  Records ofsys_dict`
-- ----------------------------
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 1, 'log_type', '日志类型', SYSDATE, SYSDATE, '异常、正常', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 2, 'social_type', '社交登录', SYSDATE, SYSDATE, '微信、QQ', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 4, 'job_type', '定时任务类型', SYSDATE, SYSDATE, 'quartz', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 5, 'job_status', '定时任务状态', SYSDATE, SYSDATE, '发布状态、运行状态', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 6, 'job_execute_status', '定时任务执行状态', SYSDATE, SYSDATE, '正常、异常', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 7, 'misfire_policy', '定时任务错失执行策略', SYSDATE, SYSDATE, '周期', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 8, 'status_type', '状态', SYSDATE, SYSDATE, '状态', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 3, 'param_type', '参数配置', SYSDATE, SYSDATE, '检索、原文、报表、安全、文档、消息、其他', '1', '0', 1 );
INSERT INTO sys_dict ( id, TYPE, description, create_time, update_time, remarks, system_flag, del_flag, tenant_id )
VALUES
	( 9, 'dict_type', '字典类型', SYSDATE, SYSDATE, '系统类不能修改', '1', '0', 1 );
INSERT INTO sys_dict
VALUES
	( 10, 'message_type', '消息公告类型', SYSDATE, SYSDATE, '通知、公告', '1', '0', 1 );
INSERT INTO sys_dict
VALUES
	( 11, 'msg_channel', '消息发送方式', SYSDATE, SYSDATE, '短信、邮件、站内信', '1', '0', 1 );
INSERT INTO sys_dict
VALUES
	( 12, 'msg_time_type', '消息发送时间', SYSDATE, SYSDATE, '即时、定时', '1', '0', 1 );
INSERT INTO sys_dict
VALUES
	( 13, 'msg_status', '消息状态', SYSDATE, SYSDATE, '已读、未读', '1', '0', 1 );
COMMIT;
-- ----------------------------
--  Records ofsys_dict_item`
-- ----------------------------
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 1, 1, '9', '异常', 'log_type', '日志异常', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 2, 1, '0', '正常', 'log_type', '日志正常', 0, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 3, 2, 'WX', '微信', 'social_type', '微信登录', 0, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 4, 2, 'QQ', 'QQ', 'social_type', 'QQ登录', 0, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 9, 4, '1', 'java类', 'job_type', 'java类', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 10, 4, '2', 'spring bean', 'job_type', 'spring bean容器实例', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 11, 4, '9', '其他', 'job_type', '其他类型', 9, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 12, 4, '3', 'Rest 调用', 'job_type', 'Rest 调用', 3, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 13, 4, '4', 'jar', 'job_type', 'jar类型', 4, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 14, 5, '1', '未发布', 'job_status', '未发布', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 15, 5, '2', '运行中', 'job_status', '运行中', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 16, 5, '3', '暂停', 'job_status', '暂停', 3, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 17, 6, '0', '正常', 'job_execute_status', '正常', 0, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 18, 6, '1', '异常', 'job_execute_status', '异常', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 19, 7, '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 20, 7, '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 21, 7, '3', '下周期执行', 'misfire_policy', '下周期执行', 3, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 22, 8, '0', '正常', 'status_type', '状态正常', 0, SYSDATE, SYSDATE, '状态正常', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 23, 8, '9', '冻结', 'status_type', '状态冻结', 1, SYSDATE, SYSDATE, '状态冻结', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 29, 3, '1', '检索', 'param_type', '检索', 0, SYSDATE, SYSDATE, '检索', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 30, 3, '2', '原文', 'param_type', '原文', 0, SYSDATE, SYSDATE, '原文', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 31, 3, '3', '报表', 'param_type', '报表', 0, SYSDATE, SYSDATE, '报表', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 32, 3, '4', '安全', 'param_type', '安全', 0, SYSDATE, SYSDATE, '安全', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 33, 3, '5', '文档', 'param_type', '文档', 0, SYSDATE, SYSDATE, '文档', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 34, 3, '6', '消息', 'param_type', '消息', 0, SYSDATE, SYSDATE, '消息', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 35, 3, '9', '其他', 'param_type', '其他', 0, SYSDATE, SYSDATE, '其他', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 36, 3, '0', '默认', 'param_type', '默认', 0, SYSDATE, SYSDATE, '默认', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 37, 9, '1', '系统类', 'dict_type', '系统类字典', 0, SYSDATE, SYSDATE, '不能修改删除', '0', 1 );
INSERT INTO sys_dict_item ( id, dict_id, value, label, TYPE, description, sort, create_time, update_time, remarks, del_flag, tenant_id )
VALUES
	( 38, 9, '0', '业务类', 'dict_type', '业务类字典', 0, SYSDATE, SYSDATE, '可以修改', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 39, 10, '1', '通知', 'message_type', '通知', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 40, 10, '2', '公告', 'message_type', '公告', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 41, 11, '1', '短信', 'msg_channel', '短信', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 42, 11, '2', '邮件', 'msg_channel', '邮件', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 43, 11, '3', '站内信', 'msg_channel', '站内信', 3, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 44, 12, '1', '即时', 'msg_time_type', '即时', 1, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 45, 12, '2', '定时', 'msg_time_type', '定时', 2, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 46, 13, '0', '未读', 'msg_status', '未读', 0, SYSDATE, SYSDATE, '', '0', 1 );
INSERT INTO sys_dict_item
VALUES
	( 47, 13, '1', '已读', 'msg_status', '已读', 1, SYSDATE, SYSDATE, '', '0', 1 );
COMMIT;
-- ----------------------------
-- Records of sys_public_param
-- ----------------------------
INSERT INTO sys_public_param VALUES (1, '租户默认来源', 'TENANT_DEFAULT_ID', '1', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
INSERT INTO sys_public_param VALUES (2, '租户默认部门名称', 'TENANT_DEFAULT_DEPTNAME', '租户默认部门', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
INSERT INTO sys_public_param VALUES (3, '租户默认账户', 'TENANT_DEFAULT_USERNAME', 'admin', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
INSERT INTO sys_public_param VALUES (4, '租户默认密码', 'TENANT_DEFAULT_PASSWORD', '123456', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
INSERT INTO sys_public_param VALUES (5, '租户默认角色编码', 'TENANT_DEFAULT_ROLECODE', 'ROLE_ADMIN', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
INSERT INTO sys_public_param VALUES (6, '租户默认角色名称', 'TENANT_DEFAULT_ROLENAME', '租户默认角色', '0', '', SYSDATE, NULL, '2', '1', '0', 1);
COMMIT;
-- ----------------------------
--  Records ofsys_menu`
-- ----------------------------
INSERT INTO sys_menu
VALUES
	( 1000, '系统管理', '', '/admin', - 1, 'fa fa-gear', 7, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1100, '用户管理', '', '/admin/user/index', 1000, '', 1, '1', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1101, '用户新增', 'sys_user_add', NULL, 1100, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1102, '用户修改', 'sys_user_edit', NULL, 1100, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1103, '用户删除', 'sys_user_del', NULL, 1100, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1200, '菜单管理', '', '/admin/menu/index', 1000, '', 2, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1201, '菜单新增', 'sys_menu_add', NULL, 1200, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1202, '菜单修改', 'sys_menu_edit', NULL, 1200, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1203, '菜单删除', 'sys_menu_del', NULL, 1200, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1300, '角色管理', '', '/admin/role/index', 1000, '', 3, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1301, '角色新增', 'sys_role_add', NULL, 1300, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1302, '角色修改', 'sys_role_edit', NULL, 1300, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1303, '角色删除', 'sys_role_del', NULL, 1300, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1304, '分配权限', 'sys_role_perm', NULL, 1300, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1400, '部门管理', '', '/admin/dept/index', 1000, '', 4, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1401, '部门新增', 'sys_dept_add', NULL, 1400, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1402, '部门修改', 'sys_dept_edit', NULL, 1400, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1403, '部门删除', 'sys_dept_del', NULL, 1400, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1500, '字典管理', '', '/admin/dict/index', 1000, '', 5, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1501, '字典新增', 'sys_dict_add', '', 1500, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1502, '字典修改', 'sys_dict_edit', '', 1500, '1', 1, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 1503, '字典删除', 'sys_dict_del', '', 1500, '1', 2, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2100, '日志管理', '', '/admin/log/index', 1000, '', 6, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2101, '日志删除', 'sys_log_del', NULL, 2100, NULL, NULL, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2210, '参数管理', '', '/admin/param/index', 1000, '', 7, '1', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2211, '参数新增', 'admin_syspublicparam_add', NULL, 2210, NULL, 1, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2212, '参数删除', 'admin_syspublicparam_del', NULL, 2210, NULL, 1, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2213, '参数编辑', 'admin_syspublicparam_edit', NULL, 2210, NULL, 1, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2300, '代码生成', '', '/tool/gen', 10006, '', 1, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2800, 'Quartz管理', '', '/admin/job/index', 1000, '', 8, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2810, '任务新增', 'job_sys_job_add', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2820, '任务修改', 'job_sys_job_edit', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2830, '任务删除', 'job_sys_job_del', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2840, '任务暂停', 'job_sys_job_shutdown_job', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2850, '任务启动', 'job_sys_job_start_job', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2860, '任务重置', 'job_sys_job_refresh_job', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 2870, '执行任务', 'job_sys_job_run_job', NULL, 2800, '1', 0, '0', '1', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 3000, '系统监控', '', '/daemon', - 1, 'fa fa-video-camera', 8, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 3110, '数据监控', '', '/monitor/data', 3000, '', 1, '1', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 3620, '服务监控', '', '/monitor/server', 3000, '', 2, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 3621, '缓存监控', '', '/monitor/cache', 3000, '', 3, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10000, '文件管理', '', '/admin/file/index', 1000, '', 9, '1', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10001, '删除文件', 'sys_file_del', NULL, 10000, NULL, 1, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10002, '表单构建', '', '/tool/build', 10006, '', 2, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10006, '系统开发', '', '/gen', - 1, 'fa fa-bars', 9, '1', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10011, '接口文档', '', '/tool/swagger', 10006, '', 3, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10012, '消息发送', NULL, '/message', - 1, 'fa fa-bell', 10, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10013, '消息管理', NULL, '/msg/messages/index', 10012, 'icon-gongzhonghao', 1, '0', '0', SYSDATE, SYSDATE, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10014, '新增', 'msg_add', NULL, 10013, NULL, 1, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10015, '编辑', 'msg_edit', NULL, 10013, NULL, 2, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
	( 10016, '删除', 'msg_del', NULL, 10013, NULL, 3, '0', '1', SYSDATE, NULL, '0' , 1);
INSERT INTO sys_menu
VALUES
    (10018, '组件示例', '', '/tool/example', 10006, '', 4, '0', '0', SYSDATE, NULL, '0', 1);   
INSERT INTO sys_menu VALUES (1600, '租户管理', '', '/admin/tenant/index', 1000, '', 10, '0', '0', SYSDATE, NULL, '0', 1);
INSERT INTO sys_menu VALUES (1601, '租户新增', 'admin_systenant_add', NULL, 1600, '1', 0, '0', '1', SYSDATE, NULL, '0', 1);
INSERT INTO sys_menu VALUES (1602, '租户修改', 'admin_systenant_edit', NULL, 1600, '1', 1, '0', '1', SYSDATE, NULL, '0', 1);
INSERT INTO sys_menu VALUES (1603, '租户删除', 'admin_systenant_del', NULL, 1600, '1', 2, '0', '1', SYSDATE, NULL, '0', 1);
COMMIT;
-- ----------------------------
--  Records ofsys_role`
-- ----------------------------
INSERT INTO sys_role
VALUES
	( '1', '管理员', 'ROLE_ADMIN', '管理员', '0', '2', SYSDATE, SYSDATE, '0', '1' );
COMMIT;
-- ----------------------------
--  Records ofsys_role_menu`
-- ----------------------------
INSERT INTO sys_role_menu
VALUES
	( 1, 1000 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1100 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1101 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1102 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1103 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1200 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1201 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1202 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1203 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1300 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1301 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1302 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1303 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1304 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1400 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1401 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1402 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1403 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1500 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1501 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1502 );
INSERT INTO sys_role_menu
VALUES
	( 1, 1503 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2100 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2101 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2210 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2211 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2212 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2213 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2300 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2800 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2810 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2820 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2830 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2840 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2850 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2860 );
INSERT INTO sys_role_menu
VALUES
	( 1, 2870 );
INSERT INTO sys_role_menu
VALUES
	( 1, 3000 );
INSERT INTO sys_role_menu
VALUES
	( 1, 3110 );
INSERT INTO sys_role_menu
VALUES
	( 1, 3620 );
INSERT INTO sys_role_menu
VALUES
	( 1, 3621 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10000 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10001 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10002 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10006 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10011 );
INSERT INTO sys_role_menu
VALUES
	( 1, 10018 );
INSERT INTO sys_role_menu VALUES (1, 1600);
INSERT INTO sys_role_menu VALUES (1, 1601);
INSERT INTO sys_role_menu VALUES (1, 1602);
INSERT INTO sys_role_menu VALUES (1, 1603);
INSERT INTO sys_role_menu VALUES (1, 3621);
COMMIT;
-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
INSERT INTO sys_tenant VALUES (1, '北京分公司', '1', SYSDATE, SYSDATE, '0', '0', SYSDATE, SYSDATE);
COMMIT;
-- ----------------------------
--  Records ofsys_user`
-- ----------------------------
INSERT INTO sys_user
VALUES
	(
		'1',
		'admin',
		'管理员',
		'$2a$10$MWa9awUairBJY09AehOdP.zfoAXWRa4Tdja1TFBvYmEub0vbHeuFm',
		'',
		'17034642889',
		'',
		'',
		'1',
		'',
		SYSDATE,
		SYSDATE,
		'0',
		'0',
		'o_0FT0uyg_H1vVy2H0JpSwlVGhWQ',
		NULL,
		NULL,
		NULL,
		NULL,
		'1' 
	);
COMMIT;
-- ----------------------------
--  Records ofsys_user_role`
-- ----------------------------
INSERT INTO sys_user_role
VALUES
	( '1', '1' );
COMMIT;
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (1, '导出_业务组件', 'bc_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (2, '导出_技术组件', 'tc_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (3, '配置_项目', 'project_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (4, '配置_银行', 'bank_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (5, '快捷打开方式_java文件', 'java_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (6, '快捷打开方式_技术模板', 'ct_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (7, '更新_业务组件', 'bc_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (8, '配置_报文', 'msg_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (9, '配置_交易', 'serviceFolder_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (10, '查看_技术组件', 'tc_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (11, '配置_模板', 'template_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (12, '部署_技术组件', 'tc_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (13, '创建_模板', 'template_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (14, '导出_技术组件清单文档', 'tcptDetail_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (15, '导出_数据字典', 'dd_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (16, '编译_交易模板', 'tt_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (17, '更新_交易模板', 'tt_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (18, '另存为_技术模板', 'ct_SaveAs');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (19, '另存为_模板', 'template_SaveAs');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (20, '创建_报文', 'msg_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (21, '导出_业务模板', 'st_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (22, '导出_交易模板', 'tt_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (23, '生成_报文', 'msg_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (24, '上传_交易', 'serviceFolder_Upload');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (25, '打包_模板', 'template_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (26, '生成_交易', 'serviceFolder_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (27, '修改_交易', 'serviceFolder_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (28, '修改_数据字典', 'dd_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (29, '生成_java文件', 'java_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (30, '快捷打开方式_业务组件', 'bc_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (31, '编译_交易', 'serviceFolder_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (32, '引用_模板', 'template_Ref');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (33, '配置_技术组件', 'tc_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (34, '删除_项目', 'project_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (35, '修改_项目', 'project_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (36, '快捷打开方式_交易模板', 'tt_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (37, '删除_流程配置', 'tp_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (38, '删除_业务组件', 'bc_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (39, '部署_流程配置', 'tp_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (40, '创建_业务组件', 'bc_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (41, '创建_数据字典', 'dd_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (42, '引用_技术模板', 'ct_Ref');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (43, '创建_技术组件', 'tc_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (44, '快捷打开方式_交易', 'serviceFolder_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (45, '打包_组件包', 'cptPackage_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (46, '查看_交易模板', 'tt_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (47, '更新_组件包', 'cptPackage_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (48, '删除_技术组件', 'tc_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (49, '生成_业务模板', 'st_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (50, '查看_项目', 'project_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (51, '删除_组件包', 'cptPackage_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (52, '修改_交易模板', 'tt_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (53, '调试_报文', 'msg_Debug');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (54, '更新_数据字典', 'dd_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (55, '注册_组件包', 'cptPackage_Regist');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (56, '删除_模板', 'template_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (57, '查看_流程配置', 'tp_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (58, '修改_模板', 'template_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (59, '配置_数据字典', 'dd_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (60, '导出_组件包', 'cptPackage_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (61, '导出_平台', 'platform_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (62, '打包_数据实体类', 'edm_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (63, '查看_模板', 'template_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (64, '配置_流程配置', 'tp_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (65, '删除_技术模板', 'ct_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (66, '配置_组件包', 'cptPackage_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (67, '查看_平台', 'platform_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (68, '快捷打开方式_技术组件', 'tc_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (69, '快捷打开方式_业务模板', 'st_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (70, '编译_技术组件', 'tc_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (71, '编译_业务模板', 'st_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (72, '导出_项目', 'project_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (73, '修改_技术组件', 'tc_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (74, '部署_组件包', 'cptPackage_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (75, '删除_java文件', 'java_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (76, '修改_业务模板', 'st_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (77, '更新_模板', 'template_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (78, '生成_业务组件', 'bc_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (79, '生成_平台', 'platform_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (80, '导出_java文件', 'java_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (81, '配置_交易模板', 'tt_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (82, '创建_流程配置', 'tp_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (83, '编译_业务组件', 'bc_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (84, '查看_java文件', 'java_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (85, '打包_业务组件', 'bc_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (86, '创建_交易模板', 'tt_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (87, '创建_业务模板', 'st_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (88, '编译_模板', 'template_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (89, '部署_交易模板', 'tt_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (90, '查看_业务组件', 'bc_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (91, '更新_技术模板', 'ct_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (92, '导出_报文', 'msg_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (93, '删除_数据字典', 'dd_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (94, '更新_项目', 'project_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (95, '另存为_业务模板', 'st_SaveAs');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (96, '删除_报文', 'msg_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (97, '上传_项目', 'project_Upload');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (98, '打包_交易', 'serviceFolder_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (99, '创建_交易', 'serviceFolder_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (100, '查看_组件包', 'cptPackage_Browse');
commit;
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (101, '快捷打开方式_组件包', 'cptPackage_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (102, '生成_组件包', 'cptPackage_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (103, '查看_数据字典', 'dd_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (104, '部署_业务组件', 'bc_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (105, '编译_组件包', 'cptPackage_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (106, '导出_业务组件清单文档', 'bcptDetail_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (107, '生成_数据字典', 'dd_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (108, '部署_交易', 'serviceFolder_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (109, '配置_平台', 'platform_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (110, '编译_项目', 'project_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (111, '打包_项目', 'project_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (112, '部署_技术模板', 'ct_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (113, '更新_报文', 'msg_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (114, '快捷打开方式_模板', 'template_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (115, '创建_组件包', 'cptPackage_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (116, '快捷打开方式_银行', 'bank_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (117, '更新_平台', 'platform_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (118, '注册_技术组件', 'tc_Regist');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (119, '更新_java文件', 'java_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (120, '修改_报文', 'msg_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (121, '生成_模板', 'template_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (122, '查看_技术模板', 'ct_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (123, '配置_业务模板', 'st_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (124, '导出_技术模板', 'ct_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (125, '导出_交易', 'serviceFolder_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (126, '创建_技术模板', 'ct_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (127, '删除_业务模板', 'st_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (128, '删除_交易', 'serviceFolder_Delete');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (129, '查看_银行', 'bank_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (130, '快捷打开方式_项目', 'project_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (131, '快捷打开方式_报文', 'msg_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (132, '修改_技术模板', 'ct_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (133, '上传_流程配置', 'tp_Upload');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (134, '创建_项目', 'project_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (135, '更新_交易', 'serviceFolder_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (136, '配置_FTP', 'ftp_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (137, '修改_业务组件', 'bc_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (138, '更新_银行', 'bank_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (139, '修改_组件包', 'cptPackage_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (140, '配置_业务组件', 'bc_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (141, '查看_导航器', 'navigator_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (142, '部署_模板', 'template_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (143, '查看_业务模板', 'st_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (144, '更新_流程配置', 'tp_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (145, '查看_交易', 'serviceFolder_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (146, '快捷打开方式_流程配置', 'tp_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (147, '编译_流程配置', 'tp_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (148, '导出_业务组件详情文档', 'bcptDoc_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (149, '查看_视图', 'view_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (150, '配置_java文件', 'java_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (151, '打包_技术组件', 'tc_Pack');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (152, '修改_流程配置', 'tp_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (153, '查看_透视图', 'perspective_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (154, '部署_项目', 'project_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (155, '生成_银行', 'bank_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (156, '部署_业务模板', 'st_Deploy');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (157, '生成_导航器', 'navigator_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (158, '导入_技术组件', 'tc_Import');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (159, '生成_流程配置', 'tp_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (160, '快捷打开方式_数据字典', 'dd_FastOpen');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (161, '生成_技术模板', 'ct_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (162, '导出_交易详情文档', 'serviceDoc_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (163, '生成_技术组件', 'tc_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (164, '创建_java文件', 'java_Create');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (165, '编译_java文件', 'java_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (166, '生成_交易模板', 'tt_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (167, '配置_技术模板', 'ct_Config');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (168, '另存为_交易模板', 'tt_SaveAs');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (169, '编译_技术模板', 'ct_Compile');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (170, '导出_交易清单文档', 'serviceDetail_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (171, '更新_技术组件', 'tc_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (172, '修改_java文件', 'java_Modify');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (173, '导出_模板', 'template_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (174, '更新_业务模板', 'st_Update');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (175, '导出_流程配置', 'tp_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (176, '查看_报文', 'msg_Browse');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (177, '导出_银行', 'bank_Export');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (178, '生成_项目', 'project_Generate');
insert into SYS_IDEPERMISSION (id, perm_name, perm_code)
values (179, '删除_交易模板', 'tt_Delete');
commit;


CREATE OR REPLACE TRIGGER SYS_DEPT_TRIGGER 
  BEFORE INSERT 
  ON SYS_DEPT 
  FOR EACH ROW
DECLARE
BEGIN
  SELECT
    SYS_DEPT_AUTO_SEQ.NEXTVAL INTO :NEW.DEPT_ID 
  FROM
    DUAL;
END;
/
-- 创建 SYS_DICT 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_DICT_TRIGGER  
  BEFORE INSERT  
  ON SYS_DICT  
  FOR EACH ROW
DECLARE
BEGIN
  SELECT
    SYS_DICT_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_DICT_ITEM 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_DICT_ITEM_TRIGGER  
  BEFORE INSERT  
  ON SYS_DICT_ITEM  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_DICT_ITEM_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_FILE 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_FILE_TRIGGER  
  BEFORE INSERT  
  ON SYS_FILE  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_FILE_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_LOG 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_LOG_TRIGGER  
  BEFORE INSERT  
  ON SYS_LOG  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_LOG_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_MENU 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_MENU_TRIGGER  
  BEFORE INSERT  
  ON SYS_MENU  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_MENU_AUTO_SEQ.NEXTVAL INTO :NEW.MENU_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_PUBLIC_PARAM 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_PUBLIC_PARAM_TRIGGER  
  BEFORE INSERT  
  ON SYS_PUBLIC_PARAM  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_PUBLIC_PARAM_AUTO_SEQ.NEXTVAL INTO :NEW.PUBLIC_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_ROLE 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_ROLE_TRIGGER  
  BEFORE INSERT  
  ON SYS_ROLE  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_ROLE_AUTO_SEQ.NEXTVAL INTO :NEW.ROLE_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_USER 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_USER_TRIGGER  
  BEFORE INSERT  
  ON SYS_USER  
  FOR EACH ROW
DECLARE
BEGIN
  SELECT
    SYS_USER_AUTO_SEQ.NEXTVAL INTO :NEW.USER_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_WELCOME 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_WELCOME_TRIGGER  
  BEFORE INSERT  
  ON SYS_WELCOME  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_WELCOME_AUTO_SEQ.NEXTVAL INTO :NEW.WEL_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_MESSAGES 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_MESSAGES_TRIGGER  
  BEFORE INSERT  
  ON SYS_MESSAGES  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_MESSAGES_AUTO_SEQ.NEXTVAL INTO :NEW.MSG_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_MSG_RESULT 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_MSG_RESULT_TRIGGER  
  BEFORE INSERT  
  ON SYS_MSG_RESULT  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_MSG_RESULT_AUTO_SEQ.NEXTVAL INTO :NEW.RESULT_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_MSG_DEPT 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_MSG_DEPT_TRIGGER  
  BEFORE INSERT  
  ON SYS_MSG_DEPT  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_MSG_DEPT_AUTO_SEQ.NEXTVAL INTO :NEW.MSG_DEPT_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_MSG_ROLE 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_MSG_ROLE_TRIGGER  
  BEFORE INSERT  
  ON SYS_MSG_ROLE  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_MSG_ROLE_AUTO_SEQ.NEXTVAL INTO :NEW.MSG_ROLE_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 GEN_TABLE 触发器TRIGGER
CREATE OR REPLACE TRIGGER GEN_TABLE_TRIGGER  
  BEFORE INSERT  
  ON GEN_TABLE  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    GEN_TABLE_AUTO_SEQ.NEXTVAL INTO :NEW.TABLE_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 GEN_TABLE_COLUMN 触发器TRIGGER
CREATE OR REPLACE TRIGGER GEN_TABLE_COLUMN_TRIGGER  
  BEFORE INSERT  
  ON GEN_TABLE_COLUMN  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    GEN_TABLE_COLUMN_AUTO_SEQ.NEXTVAL INTO :NEW.COLUMN_ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_IDEPERMISSION 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_IDEPER_TRIGGER  
  BEFORE INSERT  
  ON SYS_IDEPERMISSION  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_IDEPERMISSION_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;
/
-- 创建 SYS_IDEPERM_ROLE 触发器TRIGGER
CREATE OR REPLACE TRIGGER SYS_IDE_ROLE_TRIGGER  
  BEFORE INSERT  
  ON SYS_IDEPERM_ROLE  
  FOR EACH ROW 
DECLARE
BEGIN
  SELECT
    SYS_IDEPERM_ROLE_AUTO_SEQ.NEXTVAL INTO :NEW.ID 
  FROM
    DUAL;
  
END;